package com.ml.mall.mapper.other;

import com.ml.mall.entity.seq.SysSeq;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

/**
 * Created by kyyang on 2021/1/17 16:42
 */
@Mapper
@Repository
public interface TestMapper {



    @Update("update sys_credit set credit_balance = #{amt} where id = #{id}")
    int updateBalance(@Param("id") String id,@Param("amt") double amt);

    @Select("select credit_balance from sys_credit where id = #{id}")
    double selectByBalance(@Param("id") String id);



}
